Overview
Brought to you by YData
Dataset statistics
| Number of variables | 21 |
|---|---|
| Number of observations | 17290 |
| Missing cells | 7 |
| Missing cells (%) | < 0.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 2.8 MiB |
| Average record size in memory | 168.0 B |
Variable types
| Numeric | 17 |
|---|---|
| DateTime | 1 |
| Categorical | 3 |
bathrooms is highly overall correlated with bedrooms and 7 other fields | High correlation |
bedrooms is highly overall correlated with bathrooms and 2 other fields | High correlation |
floors is highly overall correlated with bathrooms and 3 other fields | High correlation |
grade is highly overall correlated with bathrooms and 6 other fields | High correlation |
long is highly overall correlated with zipcode | High correlation |
price is highly overall correlated with bathrooms and 4 other fields | High correlation |
sqft_above is highly overall correlated with bathrooms and 6 other fields | High correlation |
sqft_living is highly overall correlated with bathrooms and 5 other fields | High correlation |
sqft_living15 is highly overall correlated with bathrooms and 4 other fields | High correlation |
sqft_lot is highly overall correlated with sqft_lot15 | High correlation |
sqft_lot15 is highly overall correlated with sqft_lot | High correlation |
view is highly overall correlated with waterfront | High correlation |
waterfront is highly overall correlated with view | High correlation |
yr_built is highly overall correlated with bathrooms and 2 other fields | High correlation |
zipcode is highly overall correlated with long | High correlation |
waterfront is highly imbalanced (93.2%) | Imbalance |
view is highly imbalanced (71.8%) | Imbalance |
sqft_basement has 10480 (60.6%) zeros | Zeros |
yr_renovated has 16533 (95.6%) zeros | Zeros |
Reproduction
| Analysis started | 2025-10-02 20:00:03.166027 |
|---|---|
| Analysis finished | 2025-10-02 20:00:37.956071 |
| Duration | 34.79 seconds |
| Software version | ydata-profiling vv4.17.0 |
| Download configuration | config.json |
Variables
id
Real number (ℝ)
| Distinct | 17169 |
|---|---|
| Distinct (%) | 99.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.5644764 × 109 |
| Minimum | 1000102 |
|---|---|
| Maximum | 9.895 × 109 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 135.2 KiB |
Quantile statistics
| Minimum | 1000102 |
|---|---|
| 5-th percentile | 5.2204911 × 108 |
| Q1 | 2.1254 × 109 |
| median | 3.9023003 × 109 |
| Q3 | 7.2979251 × 109 |
| 95-th percentile | 9.290856 × 109 |
| Maximum | 9.895 × 109 |
| Range | 9.8939999 × 109 |
| Interquartile range (IQR) | 5.172525 × 109 |
Descriptive statistics
| Standard deviation | 2.864976 × 109 |
|---|---|
| Coefficient of variation (CV) | 0.62766806 |
| Kurtosis | -1.2463349 |
| Mean | 4.5644764 × 109 |
| Median Absolute Deviation (MAD) | 2.3772411 × 109 |
| Skewness | 0.25565765 |
| Sum | 7.8919796 × 1013 |
| Variance | 8.2080876 × 1018 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 302000375 | 2 | < 0.1% |
| 7504021310 | 2 | < 0.1% |
| 4222310010 | 2 | < 0.1% |
| 2767603612 | 2 | < 0.1% |
| 5083000375 | 2 | < 0.1% |
| 1250201165 | 2 | < 0.1% |
| 9407110710 | 2 | < 0.1% |
| 3262300940 | 2 | < 0.1% |
| 9222400605 | 2 | < 0.1% |
| 7888000390 | 2 | < 0.1% |
| Other values (17159) | 17270 |
| Value | Count | Frequency (%) |
| 1000102 | 2 | |
| 1200019 | 1 | |
| 1200021 | 1 | |
| 2800031 | 1 | |
| 3600057 | 1 | |
| 3600072 | 1 | |
| 3800008 | 1 | |
| 5200087 | 1 | |
| 6200017 | 1 | |
| 7200080 | 1 |
| Value | Count | Frequency (%) |
| 9895000040 | 1 | |
| 9842300540 | 1 | |
| 9842300485 | 1 | |
| 9842300036 | 1 | |
| 9839301165 | 1 | |
| 9839301060 | 1 | |
| 9839301055 | 1 | |
| 9839300875 | 1 | |
| 9839300775 | 1 | |
| 9839300545 | 1 |
date
Date
| Distinct | 369 |
|---|---|
| Distinct (%) | 2.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 135.2 KiB |
| Minimum | 2014-05-02 00:00:00 |
|---|---|
| Maximum | 2015-05-27 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
price
Real number (ℝ)
High correlation
| Distinct | 3562 |
|---|---|
| Distinct (%) | 20.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 542799.84 |
| Minimum | 75000 |
|---|---|
| Maximum | 7700000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 135.2 KiB |
Quantile statistics
| Minimum | 75000 |
|---|---|
| 5-th percentile | 210500 |
| Q1 | 324000 |
| median | 453000 |
| Q3 | 647500 |
| 95-th percentile | 1175000 |
| Maximum | 7700000 |
| Range | 7625000 |
| Interquartile range (IQR) | 323500 |
Descriptive statistics
| Standard deviation | 372439.03 |
|---|---|
| Coefficient of variation (CV) | 0.68614432 |
| Kurtosis | 36.366127 |
| Mean | 542799.84 |
| Median Absolute Deviation (MAD) | 152000 |
| Skewness | 4.1293833 |
| Sum | 9.3850092 × 109 |
| Variance | 1.3871083 × 1011 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 350000 | 134 | 0.8% |
| 450000 | 131 | 0.8% |
| 550000 | 127 | 0.7% |
| 425000 | 124 | 0.7% |
| 500000 | 124 | 0.7% |
| 325000 | 118 | 0.7% |
| 375000 | 113 | 0.7% |
| 400000 | 112 | 0.6% |
| 250000 | 107 | 0.6% |
| 650000 | 102 | 0.6% |
| Other values (3552) | 16098 |
| Value | Count | Frequency (%) |
| 75000 | 1 | |
| 78000 | 1 | |
| 80000 | 1 | |
| 81000 | 1 | |
| 82000 | 1 | |
| 82500 | 1 | |
| 83000 | 1 | |
| 84000 | 1 | |
| 85000 | 2 | |
| 86500 | 1 |
| Value | Count | Frequency (%) |
| 7700000 | 1 | |
| 7062500 | 1 | |
| 6885000 | 1 | |
| 5350000 | 1 | |
| 5300000 | 1 | |
| 5110800 | 1 | |
| 4668000 | 1 | |
| 4500000 | 1 | |
| 4489000 | 1 | |
| 4000000 | 1 |
bedrooms
Real number (ℝ)
High correlation
| Distinct | 13 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 7 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.3680495 |
| Minimum | 0 |
|---|---|
| Maximum | 33 |
| Zeros | 11 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 135.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 3 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 5 |
| Maximum | 33 |
| Range | 33 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.94311768 |
|---|---|
| Coefficient of variation (CV) | 0.28001894 |
| Kurtosis | 57.730327 |
| Mean | 3.3680495 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 2.2710443 |
| Sum | 58210 |
| Variance | 0.88947095 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3 | 7830 | |
| 4 | 5437 | |
| 2 | 2257 | 13.1% |
| 5 | 1307 | 7.6% |
| 6 | 225 | 1.3% |
| 1 | 166 | 1.0% |
| 7 | 32 | 0.2% |
| 0 | 11 | 0.1% |
| 8 | 8 | < 0.1% |
| 9 | 5 | < 0.1% |
| Other values (3) | 5 | < 0.1% |
| (Missing) | 7 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 11 | 0.1% |
| 1 | 166 | 1.0% |
| 2 | 2257 | 13.1% |
| 3 | 7830 | |
| 4 | 5437 | |
| 5 | 1307 | 7.6% |
| 6 | 225 | 1.3% |
| 7 | 32 | 0.2% |
| 8 | 8 | < 0.1% |
| 9 | 5 | < 0.1% |
| Value | Count | Frequency (%) |
| 33 | 1 | < 0.1% |
| 11 | 1 | < 0.1% |
| 10 | 3 | < 0.1% |
| 9 | 5 | < 0.1% |
| 8 | 8 | < 0.1% |
| 7 | 32 | 0.2% |
| 6 | 225 | 1.3% |
| 5 | 1307 | 7.6% |
| 4 | 5437 | |
| 3 | 7830 |
bathrooms
Real number (ℝ)
High correlation
| Distinct | 30 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.1182909 |
| Minimum | 0 |
|---|---|
| Maximum | 8 |
| Zeros | 9 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 135.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1.75 |
| median | 2.25 |
| Q3 | 2.5 |
| 95-th percentile | 3.5 |
| Maximum | 8 |
| Range | 8 |
| Interquartile range (IQR) | 0.75 |
Descriptive statistics
| Standard deviation | 0.77224948 |
|---|---|
| Coefficient of variation (CV) | 0.36456252 |
| Kurtosis | 1.3422932 |
| Mean | 2.1182909 |
| Median Absolute Deviation (MAD) | 0.5 |
| Skewness | 0.51556976 |
| Sum | 36625.25 |
| Variance | 0.59636925 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2.5 | 4309 | |
| 1 | 3070 | |
| 1.75 | 2438 | |
| 2.25 | 1609 | 9.3% |
| 2 | 1549 | 9.0% |
| 1.5 | 1147 | 6.6% |
| 2.75 | 972 | 5.6% |
| 3.5 | 610 | 3.5% |
| 3 | 589 | 3.4% |
| 3.25 | 468 | 2.7% |
| Other values (20) | 529 | 3.1% |
| Value | Count | Frequency (%) |
| 0 | 9 | 0.1% |
| 0.5 | 3 | < 0.1% |
| 0.75 | 57 | 0.3% |
| 1 | 3070 | |
| 1.25 | 8 | < 0.1% |
| 1.5 | 1147 | 6.6% |
| 1.75 | 2438 | |
| 2 | 1549 | 9.0% |
| 2.25 | 1609 | 9.3% |
| 2.5 | 4309 |
| Value | Count | Frequency (%) |
| 8 | 2 | < 0.1% |
| 7.75 | 1 | < 0.1% |
| 7.5 | 1 | < 0.1% |
| 6.75 | 2 | < 0.1% |
| 6.5 | 2 | < 0.1% |
| 6.25 | 2 | < 0.1% |
| 6 | 3 | < 0.1% |
| 5.75 | 1 | < 0.1% |
| 5.5 | 9 | |
| 5.25 | 8 |
sqft_living
Real number (ℝ)
High correlation
| Distinct | 942 |
|---|---|
| Distinct (%) | 5.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2081.4167 |
| Minimum | 290 |
|---|---|
| Maximum | 13540 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 135.2 KiB |
Quantile statistics
| Minimum | 290 |
|---|---|
| 5-th percentile | 930 |
| Q1 | 1420 |
| median | 1920 |
| Q3 | 2550 |
| 95-th percentile | 3780 |
| Maximum | 13540 |
| Range | 13250 |
| Interquartile range (IQR) | 1130 |
Descriptive statistics
| Standard deviation | 923.24458 |
|---|---|
| Coefficient of variation (CV) | 0.44356547 |
| Kurtosis | 5.5925159 |
| Mean | 2081.4167 |
| Median Absolute Deviation (MAD) | 550 |
| Skewness | 1.49953 |
| Sum | 35987695 |
| Variance | 852380.55 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1400 | 118 | 0.7% |
| 1440 | 112 | 0.6% |
| 1800 | 110 | 0.6% |
| 1300 | 106 | 0.6% |
| 1010 | 103 | 0.6% |
| 1560 | 101 | 0.6% |
| 1540 | 100 | 0.6% |
| 1660 | 98 | 0.6% |
| 1320 | 96 | 0.6% |
| 1820 | 96 | 0.6% |
| Other values (932) | 16250 |
| Value | Count | Frequency (%) |
| 290 | 1 | |
| 380 | 1 | |
| 390 | 2 | |
| 420 | 1 | |
| 430 | 1 | |
| 440 | 1 | |
| 460 | 1 | |
| 470 | 1 | |
| 480 | 2 | |
| 490 | 1 |
| Value | Count | Frequency (%) |
| 13540 | 1 | |
| 12050 | 1 | |
| 10040 | 1 | |
| 9890 | 1 | |
| 9640 | 1 | |
| 8670 | 1 | |
| 8020 | 1 | |
| 8010 | 1 | |
| 8000 | 1 | |
| 7880 | 1 |
sqft_lot
Real number (ℝ)
High correlation
| Distinct | 8431 |
|---|---|
| Distinct (%) | 48.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15241.884 |
| Minimum | 520 |
|---|---|
| Maximum | 1651359 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 135.2 KiB |
Quantile statistics
| Minimum | 520 |
|---|---|
| 5-th percentile | 1750 |
| Q1 | 5033.25 |
| median | 7588.5 |
| Q3 | 10713 |
| 95-th percentile | 43560 |
| Maximum | 1651359 |
| Range | 1650839 |
| Interquartile range (IQR) | 5679.75 |
Descriptive statistics
| Standard deviation | 42270.28 |
|---|---|
| Coefficient of variation (CV) | 2.7732975 |
| Kurtosis | 277.26071 |
| Mean | 15241.884 |
| Median Absolute Deviation (MAD) | 2626.5 |
| Skewness | 12.86597 |
| Sum | 2.6353218 × 108 |
| Variance | 1.7867766 × 109 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5000 | 297 | 1.7% |
| 6000 | 243 | 1.4% |
| 4000 | 200 | 1.2% |
| 7200 | 176 | 1.0% |
| 4800 | 100 | 0.6% |
| 4500 | 95 | 0.5% |
| 7500 | 84 | 0.5% |
| 3600 | 84 | 0.5% |
| 8400 | 82 | 0.5% |
| 9600 | 81 | 0.5% |
| Other values (8421) | 15848 |
| Value | Count | Frequency (%) |
| 520 | 1 | |
| 572 | 1 | |
| 600 | 1 | |
| 609 | 1 | |
| 635 | 1 | |
| 638 | 1 | |
| 649 | 2 | |
| 651 | 1 | |
| 675 | 1 | |
| 676 | 1 |
| Value | Count | Frequency (%) |
| 1651359 | 1 | |
| 1074218 | 1 | |
| 1024068 | 1 | |
| 982278 | 1 | |
| 920423 | 1 | |
| 881654 | 1 | |
| 871200 | 2 | |
| 843309 | 1 | |
| 715690 | 1 | |
| 641203 | 1 |
floors
Real number (ℝ)
High correlation
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.4980625 |
| Minimum | 1 |
|---|---|
| Maximum | 3.5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 135.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1.5 |
| Q3 | 2 |
| 95-th percentile | 2 |
| Maximum | 3.5 |
| Range | 2.5 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.54260257 |
|---|---|
| Coefficient of variation (CV) | 0.3622029 |
| Kurtosis | -0.46267765 |
| Mean | 1.4980625 |
| Median Absolute Deviation (MAD) | 0.5 |
| Skewness | 0.62117792 |
| Sum | 25901.5 |
| Variance | 0.29441755 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 8496 | |
| 2 | 6588 | |
| 1.5 | 1549 | 9.0% |
| 3 | 513 | 3.0% |
| 2.5 | 137 | 0.8% |
| 3.5 | 7 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 8496 | |
| 1.5 | 1549 | 9.0% |
| 2 | 6588 | |
| 2.5 | 137 | 0.8% |
| 3 | 513 | 3.0% |
| 3.5 | 7 | < 0.1% |
| Value | Count | Frequency (%) |
| 3.5 | 7 | < 0.1% |
| 3 | 513 | 3.0% |
| 2.5 | 137 | 0.8% |
| 2 | 6588 | |
| 1.5 | 1549 | 9.0% |
| 1 | 8496 |
waterfront
Categorical
High correlation Imbalance
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 135.2 KiB |
| 0 | |
|---|---|
| 1 | 141 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 17149 | |
| 1 | 141 | 0.8% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 17149 | |
| 1 | 141 | 0.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 17149 | |
| 1 | 141 | 0.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 17290 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 17149 | |
| 1 | 141 | 0.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 17290 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 17149 | |
| 1 | 141 | 0.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 17290 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 17149 | |
| 1 | 141 | 0.8% |
view
Categorical
High correlation Imbalance
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 135.2 KiB |
| 0 | |
|---|---|
| 2 | 788 |
| 3 | 406 |
| 1 | 278 |
| 4 | 261 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 15557 | |
| 2 | 788 | 4.6% |
| 3 | 406 | 2.3% |
| 1 | 278 | 1.6% |
| 4 | 261 | 1.5% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 15557 | |
| 2 | 788 | 4.6% |
| 3 | 406 | 2.3% |
| 1 | 278 | 1.6% |
| 4 | 261 | 1.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 15557 | |
| 2 | 788 | 4.6% |
| 3 | 406 | 2.3% |
| 1 | 278 | 1.6% |
| 4 | 261 | 1.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 17290 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 15557 | |
| 2 | 788 | 4.6% |
| 3 | 406 | 2.3% |
| 1 | 278 | 1.6% |
| 4 | 261 | 1.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 17290 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 15557 | |
| 2 | 788 | 4.6% |
| 3 | 406 | 2.3% |
| 1 | 278 | 1.6% |
| 4 | 261 | 1.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 17290 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 15557 | |
| 2 | 788 | 4.6% |
| 3 | 406 | 2.3% |
| 1 | 278 | 1.6% |
| 4 | 261 | 1.5% |
condition
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 135.2 KiB |
| 3 | |
|---|---|
| 4 | |
| 5 | |
| 2 | 139 |
| 1 | 25 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 4 |
|---|---|
| 2nd row | 4 |
| 3rd row | 3 |
| 4th row | 3 |
| 5th row | 3 |
Common Values
| Value | Count | Frequency (%) |
| 3 | 11259 | |
| 4 | 4513 | |
| 5 | 1354 | 7.8% |
| 2 | 139 | 0.8% |
| 1 | 25 | 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 3 | 11259 | |
| 4 | 4513 | |
| 5 | 1354 | 7.8% |
| 2 | 139 | 0.8% |
| 1 | 25 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 3 | 11259 | |
| 4 | 4513 | |
| 5 | 1354 | 7.8% |
| 2 | 139 | 0.8% |
| 1 | 25 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 17290 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 3 | 11259 | |
| 4 | 4513 | |
| 5 | 1354 | 7.8% |
| 2 | 139 | 0.8% |
| 1 | 25 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 17290 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 3 | 11259 | |
| 4 | 4513 | |
| 5 | 1354 | 7.8% |
| 2 | 139 | 0.8% |
| 1 | 25 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 17290 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 3 | 11259 | |
| 4 | 4513 | |
| 5 | 1354 | 7.8% |
| 2 | 139 | 0.8% |
| 1 | 25 | 0.1% |
grade
Real number (ℝ)
High correlation
| Distinct | 12 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.6600347 |
| Minimum | 1 |
|---|---|
| Maximum | 13 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 135.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 6 |
| Q1 | 7 |
| median | 7 |
| Q3 | 8 |
| 95-th percentile | 10 |
| Maximum | 13 |
| Range | 12 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.1764281 |
|---|---|
| Coefficient of variation (CV) | 0.15358 |
| Kurtosis | 1.2207208 |
| Mean | 7.6600347 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.76483861 |
| Sum | 132442 |
| Variance | 1.3839831 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 7 | 7137 | |
| 8 | 4910 | |
| 9 | 2090 | 12.1% |
| 6 | 1623 | 9.4% |
| 10 | 896 | 5.2% |
| 11 | 331 | 1.9% |
| 5 | 196 | 1.1% |
| 12 | 68 | 0.4% |
| 4 | 23 | 0.1% |
| 13 | 12 | 0.1% |
| Other values (2) | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 1 | < 0.1% |
| 3 | 3 | < 0.1% |
| 4 | 23 | 0.1% |
| 5 | 196 | 1.1% |
| 6 | 1623 | 9.4% |
| 7 | 7137 | |
| 8 | 4910 | |
| 9 | 2090 | 12.1% |
| 10 | 896 | 5.2% |
| 11 | 331 | 1.9% |
| Value | Count | Frequency (%) |
| 13 | 12 | 0.1% |
| 12 | 68 | 0.4% |
| 11 | 331 | 1.9% |
| 10 | 896 | 5.2% |
| 9 | 2090 | 12.1% |
| 8 | 4910 | |
| 7 | 7137 | |
| 6 | 1623 | 9.4% |
| 5 | 196 | 1.1% |
| 4 | 23 | 0.1% |
sqft_above
Real number (ℝ)
High correlation
| Distinct | 853 |
|---|---|
| Distinct (%) | 4.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1788.2996 |
| Minimum | 290 |
|---|---|
| Maximum | 9410 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 135.2 KiB |
Quantile statistics
| Minimum | 290 |
|---|---|
| 5-th percentile | 840 |
| Q1 | 1190 |
| median | 1560 |
| Q3 | 2210 |
| 95-th percentile | 3415.5 |
| Maximum | 9410 |
| Range | 9120 |
| Interquartile range (IQR) | 1020 |
Descriptive statistics
| Standard deviation | 831.88962 |
|---|---|
| Coefficient of variation (CV) | 0.4651847 |
| Kurtosis | 3.5376648 |
| Mean | 1788.2996 |
| Median Absolute Deviation (MAD) | 450 |
| Skewness | 1.4686636 |
| Sum | 30919700 |
| Variance | 692040.33 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1010 | 172 | 1.0% |
| 1300 | 162 | 0.9% |
| 1200 | 160 | 0.9% |
| 1340 | 147 | 0.9% |
| 1400 | 147 | 0.9% |
| 1220 | 146 | 0.8% |
| 1180 | 142 | 0.8% |
| 1140 | 140 | 0.8% |
| 1060 | 139 | 0.8% |
| 1320 | 138 | 0.8% |
| Other values (843) | 15797 |
| Value | Count | Frequency (%) |
| 290 | 1 | < 0.1% |
| 380 | 1 | < 0.1% |
| 390 | 2 | |
| 420 | 1 | < 0.1% |
| 430 | 1 | < 0.1% |
| 440 | 1 | < 0.1% |
| 460 | 1 | < 0.1% |
| 470 | 1 | < 0.1% |
| 480 | 3 | |
| 490 | 2 |
| Value | Count | Frequency (%) |
| 9410 | 1 | |
| 8860 | 1 | |
| 8570 | 1 | |
| 8020 | 1 | |
| 7880 | 1 | |
| 7680 | 1 | |
| 7320 | 1 | |
| 6720 | 1 | |
| 6640 | 1 | |
| 6530 | 1 |
sqft_basement
Real number (ℝ)
Zeros
| Distinct | 282 |
|---|---|
| Distinct (%) | 1.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 293.11712 |
| Minimum | 0 |
|---|---|
| Maximum | 4820 |
| Zeros | 10480 |
| Zeros (%) | 60.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 135.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 570 |
| 95-th percentile | 1190 |
| Maximum | 4820 |
| Range | 4820 |
| Interquartile range (IQR) | 570 |
Descriptive statistics
| Standard deviation | 443.63039 |
|---|---|
| Coefficient of variation (CV) | 1.5134919 |
| Kurtosis | 2.8444243 |
| Mean | 293.11712 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.5809084 |
| Sum | 5067995 |
| Variance | 196807.92 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 10480 | |
| 600 | 180 | 1.0% |
| 700 | 179 | 1.0% |
| 500 | 177 | 1.0% |
| 800 | 157 | 0.9% |
| 400 | 145 | 0.8% |
| 1000 | 122 | 0.7% |
| 900 | 114 | 0.7% |
| 300 | 109 | 0.6% |
| 720 | 87 | 0.5% |
| Other values (272) | 5540 |
| Value | Count | Frequency (%) |
| 0 | 10480 | |
| 10 | 1 | < 0.1% |
| 20 | 1 | < 0.1% |
| 40 | 2 | < 0.1% |
| 50 | 10 | 0.1% |
| 60 | 7 | < 0.1% |
| 65 | 1 | < 0.1% |
| 70 | 7 | < 0.1% |
| 80 | 19 | 0.1% |
| 90 | 18 | 0.1% |
| Value | Count | Frequency (%) |
| 4820 | 1 | |
| 4130 | 1 | |
| 3500 | 1 | |
| 3480 | 1 | |
| 3260 | 1 | |
| 2850 | 1 | |
| 2730 | 1 | |
| 2720 | 1 | |
| 2600 | 1 | |
| 2590 | 1 |
yr_built
Real number (ℝ)
High correlation
| Distinct | 116 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1970.9642 |
| Minimum | 1900 |
|---|---|
| Maximum | 2015 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 135.2 KiB |
Quantile statistics
| Minimum | 1900 |
|---|---|
| 5-th percentile | 1915 |
| Q1 | 1951 |
| median | 1975 |
| Q3 | 1997 |
| 95-th percentile | 2011 |
| Maximum | 2015 |
| Range | 115 |
| Interquartile range (IQR) | 46 |
Descriptive statistics
| Standard deviation | 29.485431 |
|---|---|
| Coefficient of variation (CV) | 0.014959902 |
| Kurtosis | -0.65930366 |
| Mean | 1970.9642 |
| Median Absolute Deviation (MAD) | 23 |
| Skewness | -0.47006591 |
| Sum | 34077971 |
| Variance | 869.39064 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2014 | 450 | 2.6% |
| 2006 | 361 | 2.1% |
| 2005 | 358 | 2.1% |
| 2003 | 347 | 2.0% |
| 2004 | 341 | 2.0% |
| 1977 | 341 | 2.0% |
| 2007 | 328 | 1.9% |
| 1968 | 315 | 1.8% |
| 1978 | 309 | 1.8% |
| 2008 | 295 | 1.7% |
| Other values (106) | 13845 |
| Value | Count | Frequency (%) |
| 1900 | 73 | |
| 1901 | 23 | 0.1% |
| 1902 | 22 | 0.1% |
| 1903 | 41 | |
| 1904 | 40 | |
| 1905 | 57 | |
| 1906 | 83 | |
| 1907 | 55 | |
| 1908 | 63 | |
| 1909 | 76 |
| Value | Count | Frequency (%) |
| 2015 | 35 | 0.2% |
| 2014 | 450 | |
| 2013 | 168 | 1.0% |
| 2012 | 145 | 0.8% |
| 2011 | 107 | 0.6% |
| 2010 | 114 | 0.7% |
| 2009 | 189 | |
| 2008 | 295 | |
| 2007 | 328 | |
| 2006 | 361 |
yr_renovated
Real number (ℝ)
Zeros
| Distinct | 67 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 87.387681 |
| Minimum | 0 |
|---|---|
| Maximum | 2015 |
| Zeros | 16533 |
| Zeros (%) | 95.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 135.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 2015 |
| Range | 2015 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 408.4174 |
|---|---|
| Coefficient of variation (CV) | 4.6736267 |
| Kurtosis | 17.897003 |
| Mean | 87.387681 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.4602088 |
| Sum | 1510933 |
| Variance | 166804.77 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 16533 | |
| 2014 | 73 | 0.4% |
| 2013 | 33 | 0.2% |
| 2007 | 31 | 0.2% |
| 2000 | 30 | 0.2% |
| 2005 | 28 | 0.2% |
| 2003 | 28 | 0.2% |
| 2004 | 22 | 0.1% |
| 2009 | 22 | 0.1% |
| 1990 | 20 | 0.1% |
| Other values (57) | 470 | 2.7% |
| Value | Count | Frequency (%) |
| 0 | 16533 | |
| 1940 | 1 | < 0.1% |
| 1944 | 1 | < 0.1% |
| 1945 | 3 | < 0.1% |
| 1946 | 2 | < 0.1% |
| 1950 | 1 | < 0.1% |
| 1951 | 1 | < 0.1% |
| 1953 | 3 | < 0.1% |
| 1954 | 1 | < 0.1% |
| 1955 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 2015 | 13 | 0.1% |
| 2014 | 73 | |
| 2013 | 33 | |
| 2012 | 11 | 0.1% |
| 2011 | 11 | 0.1% |
| 2010 | 15 | 0.1% |
| 2009 | 22 | 0.1% |
| 2008 | 16 | 0.1% |
| 2007 | 31 | |
| 2006 | 15 | 0.1% |
zipcode
Real number (ℝ)
High correlation
| Distinct | 70 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 98077.935 |
| Minimum | 98001 |
|---|---|
| Maximum | 98199 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 135.2 KiB |
Quantile statistics
| Minimum | 98001 |
|---|---|
| 5-th percentile | 98004 |
| Q1 | 98033 |
| median | 98065 |
| Q3 | 98117 |
| 95-th percentile | 98177 |
| Maximum | 98199 |
| Range | 198 |
| Interquartile range (IQR) | 84 |
Descriptive statistics
| Standard deviation | 53.505656 |
|---|---|
| Coefficient of variation (CV) | 0.00054554223 |
| Kurtosis | -0.85391584 |
| Mean | 98077.935 |
| Median Absolute Deviation (MAD) | 42 |
| Skewness | 0.40020502 |
| Sum | 1.6957675 × 109 |
| Variance | 2862.8552 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 98103 | 485 | 2.8% |
| 98038 | 478 | 2.8% |
| 98052 | 458 | 2.6% |
| 98115 | 458 | 2.6% |
| 98117 | 449 | 2.6% |
| 98034 | 437 | 2.5% |
| 98042 | 422 | 2.4% |
| 98118 | 404 | 2.3% |
| 98006 | 404 | 2.3% |
| 98133 | 394 | 2.3% |
| Other values (60) | 12901 |
| Value | Count | Frequency (%) |
| 98001 | 299 | |
| 98002 | 152 | 0.9% |
| 98003 | 224 | |
| 98004 | 264 | |
| 98005 | 135 | 0.8% |
| 98006 | 404 | |
| 98007 | 111 | 0.6% |
| 98008 | 230 | |
| 98010 | 83 | 0.5% |
| 98011 | 153 | 0.9% |
| Value | Count | Frequency (%) |
| 98199 | 259 | |
| 98198 | 227 | |
| 98188 | 103 | 0.6% |
| 98178 | 197 | |
| 98177 | 208 | |
| 98168 | 204 | |
| 98166 | 203 | |
| 98155 | 360 | |
| 98148 | 47 | 0.3% |
| 98146 | 210 |
lat
Real number (ℝ)
| Distinct | 4846 |
|---|---|
| Distinct (%) | 28.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 47.560451 |
| Minimum | 47.1559 |
|---|---|
| Maximum | 47.7776 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 135.2 KiB |
Quantile statistics
| Minimum | 47.1559 |
|---|---|
| 5-th percentile | 47.309645 |
| Q1 | 47.4724 |
| median | 47.5731 |
| Q3 | 47.6779 |
| 95-th percentile | 47.7494 |
| Maximum | 47.7776 |
| Range | 0.6217 |
| Interquartile range (IQR) | 0.2055 |
Descriptive statistics
| Standard deviation | 0.1386244 |
|---|---|
| Coefficient of variation (CV) | 0.0029146989 |
| Kurtosis | -0.65607053 |
| Mean | 47.560451 |
| Median Absolute Deviation (MAD) | 0.1038 |
| Skewness | -0.50058647 |
| Sum | 822320.2 |
| Variance | 0.019216723 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 47.6711 | 16 | 0.1% |
| 47.5491 | 15 | 0.1% |
| 47.5322 | 14 | 0.1% |
| 47.6844 | 14 | 0.1% |
| 47.6374 | 14 | 0.1% |
| 47.6904 | 14 | 0.1% |
| 47.686 | 14 | 0.1% |
| 47.6647 | 13 | 0.1% |
| 47.5427 | 13 | 0.1% |
| 47.6842 | 13 | 0.1% |
| Other values (4836) | 17150 |
| Value | Count | Frequency (%) |
| 47.1559 | 1 | |
| 47.1593 | 1 | |
| 47.1622 | 1 | |
| 47.1764 | 1 | |
| 47.1775 | 1 | |
| 47.1776 | 1 | |
| 47.1795 | 1 | |
| 47.1808 | 1 | |
| 47.184 | 1 | |
| 47.1853 | 1 |
| Value | Count | Frequency (%) |
| 47.7776 | 3 | |
| 47.7775 | 2 | |
| 47.7774 | 1 | < 0.1% |
| 47.7772 | 3 | |
| 47.7771 | 2 | |
| 47.777 | 2 | |
| 47.7769 | 3 | |
| 47.7767 | 4 | |
| 47.7766 | 4 | |
| 47.7765 | 3 |
long
Real number (ℝ)
High correlation
| Distinct | 723 |
|---|---|
| Distinct (%) | 4.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -122.21419 |
| Minimum | -122.514 |
|---|---|
| Maximum | -121.315 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 17290 |
| Negative (%) | 100.0% |
| Memory size | 135.2 KiB |
Quantile statistics
| Minimum | -122.514 |
|---|---|
| 5-th percentile | -122.387 |
| Q1 | -122.328 |
| median | -122.2315 |
| Q3 | -122.125 |
| 95-th percentile | -121.98 |
| Maximum | -121.315 |
| Range | 1.199 |
| Interquartile range (IQR) | 0.203 |
Descriptive statistics
| Standard deviation | 0.14074546 |
|---|---|
| Coefficient of variation (CV) | -0.0011516294 |
| Kurtosis | 1.0205698 |
| Mean | -122.21419 |
| Median Absolute Deviation (MAD) | 0.1015 |
| Skewness | 0.88156052 |
| Sum | -2113083.4 |
| Variance | 0.019809284 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -122.29 | 92 | 0.5% |
| -122.362 | 88 | 0.5% |
| -122.3 | 85 | 0.5% |
| -122.372 | 82 | 0.5% |
| -122.291 | 80 | 0.5% |
| -122.304 | 78 | 0.5% |
| -122.375 | 78 | 0.5% |
| -122.299 | 77 | 0.4% |
| -122.288 | 77 | 0.4% |
| -122.284 | 77 | 0.4% |
| Other values (713) | 16476 |
| Value | Count | Frequency (%) |
| -122.514 | 1 | |
| -122.512 | 1 | |
| -122.511 | 2 | |
| -122.509 | 1 | |
| -122.507 | 1 | |
| -122.506 | 1 | |
| -122.505 | 2 | |
| -122.504 | 2 | |
| -122.503 | 2 | |
| -122.502 | 1 |
| Value | Count | Frequency (%) |
| -121.315 | 2 | |
| -121.319 | 1 | |
| -121.321 | 1 | |
| -121.352 | 2 | |
| -121.359 | 1 | |
| -121.364 | 1 | |
| -121.402 | 1 | |
| -121.403 | 1 | |
| -121.405 | 1 | |
| -121.417 | 1 |
sqft_living15
Real number (ℝ)
High correlation
| Distinct | 713 |
|---|---|
| Distinct (%) | 4.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1987.4751 |
| Minimum | 399 |
|---|---|
| Maximum | 6110 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 135.2 KiB |
Quantile statistics
| Minimum | 399 |
|---|---|
| 5-th percentile | 1140 |
| Q1 | 1490 |
| median | 1840 |
| Q3 | 2360 |
| 95-th percentile | 3300 |
| Maximum | 6110 |
| Range | 5711 |
| Interquartile range (IQR) | 870 |
Descriptive statistics
| Standard deviation | 686.25538 |
|---|---|
| Coefficient of variation (CV) | 0.34529006 |
| Kurtosis | 1.5683662 |
| Mean | 1987.4751 |
| Median Absolute Deviation (MAD) | 410 |
| Skewness | 1.1057171 |
| Sum | 34363444 |
| Variance | 470946.45 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1540 | 160 | 0.9% |
| 1440 | 158 | 0.9% |
| 1560 | 153 | 0.9% |
| 1500 | 149 | 0.9% |
| 1720 | 140 | 0.8% |
| 1580 | 139 | 0.8% |
| 1800 | 134 | 0.8% |
| 1610 | 132 | 0.8% |
| 1760 | 130 | 0.8% |
| 1470 | 129 | 0.7% |
| Other values (703) | 15866 |
| Value | Count | Frequency (%) |
| 399 | 1 | < 0.1% |
| 460 | 2 | < 0.1% |
| 620 | 2 | < 0.1% |
| 690 | 1 | < 0.1% |
| 700 | 2 | < 0.1% |
| 710 | 2 | < 0.1% |
| 720 | 1 | < 0.1% |
| 740 | 6 | |
| 750 | 2 | < 0.1% |
| 760 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 6110 | 1 | < 0.1% |
| 5790 | 5 | |
| 5600 | 1 | < 0.1% |
| 5500 | 1 | < 0.1% |
| 5380 | 1 | < 0.1% |
| 5340 | 1 | < 0.1% |
| 5330 | 1 | < 0.1% |
| 5220 | 1 | < 0.1% |
| 5200 | 1 | < 0.1% |
| 5110 | 1 | < 0.1% |
sqft_lot15
Real number (ℝ)
High correlation
| Distinct | 7569 |
|---|---|
| Distinct (%) | 43.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12834.458 |
| Minimum | 651 |
|---|---|
| Maximum | 871200 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 135.2 KiB |
Quantile statistics
| Minimum | 651 |
|---|---|
| 5-th percentile | 1929.15 |
| Q1 | 5100 |
| median | 7619 |
| Q3 | 10099.5 |
| 95-th percentile | 37038.4 |
| Maximum | 871200 |
| Range | 870549 |
| Interquartile range (IQR) | 4999.5 |
Descriptive statistics
| Standard deviation | 27766.935 |
|---|---|
| Coefficient of variation (CV) | 2.1634676 |
| Kurtosis | 162.92897 |
| Mean | 12834.458 |
| Median Absolute Deviation (MAD) | 2518 |
| Skewness | 9.8139161 |
| Sum | 2.2190779 × 108 |
| Variance | 7.7100266 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5000 | 348 | 2.0% |
| 4000 | 293 | 1.7% |
| 6000 | 249 | 1.4% |
| 7200 | 165 | 1.0% |
| 4800 | 115 | 0.7% |
| 7500 | 113 | 0.7% |
| 3600 | 95 | 0.5% |
| 8400 | 93 | 0.5% |
| 4500 | 90 | 0.5% |
| 5100 | 82 | 0.5% |
| Other values (7559) | 15647 |
| Value | Count | Frequency (%) |
| 651 | 1 | < 0.1% |
| 659 | 1 | < 0.1% |
| 660 | 1 | < 0.1% |
| 748 | 1 | < 0.1% |
| 750 | 4 | |
| 755 | 1 | < 0.1% |
| 758 | 1 | < 0.1% |
| 788 | 1 | < 0.1% |
| 809 | 1 | < 0.1% |
| 810 | 2 |
| Value | Count | Frequency (%) |
| 871200 | 1 | |
| 858132 | 1 | |
| 560617 | 1 | |
| 434728 | 1 | |
| 425581 | 1 | |
| 422967 | 1 | |
| 411962 | 1 | |
| 392040 | 2 | |
| 380279 | 1 | |
| 360000 | 1 |
Interactions
Correlations
| bathrooms | bedrooms | condition | floors | grade | id | lat | long | price | sqft_above | sqft_basement | sqft_living | sqft_living15 | sqft_lot | sqft_lot15 | view | waterfront | yr_built | yr_renovated | zipcode | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| bathrooms | 1.000 | 0.525 | 0.131 | 0.544 | 0.659 | 0.017 | 0.011 | 0.260 | 0.500 | 0.690 | 0.195 | 0.744 | 0.566 | 0.067 | 0.061 | 0.120 | 0.121 | 0.562 | 0.049 | -0.203 |
| bedrooms | 0.525 | 1.000 | 0.025 | 0.228 | 0.383 | 0.007 | -0.019 | 0.196 | 0.353 | 0.544 | 0.237 | 0.653 | 0.447 | 0.215 | 0.199 | 0.038 | 0.000 | 0.180 | 0.024 | -0.171 |
| condition | 0.131 | 0.025 | 1.000 | 0.182 | 0.164 | 0.029 | 0.055 | 0.084 | 0.020 | 0.109 | 0.096 | 0.060 | 0.061 | 0.011 | 0.010 | 0.026 | 0.024 | 0.251 | 0.068 | 0.076 |
| floors | 0.544 | 0.228 | 0.182 | 1.000 | 0.503 | 0.021 | 0.027 | 0.143 | 0.324 | 0.597 | -0.275 | 0.396 | 0.298 | -0.236 | -0.234 | 0.025 | 0.025 | 0.550 | 0.020 | -0.057 |
| grade | 0.659 | 0.383 | 0.164 | 0.503 | 1.000 | 0.024 | 0.104 | 0.223 | 0.657 | 0.709 | 0.095 | 0.714 | 0.656 | 0.149 | 0.155 | 0.146 | 0.127 | 0.502 | 0.021 | -0.180 |
| id | 0.017 | 0.007 | 0.029 | 0.021 | 0.024 | 1.000 | -0.004 | 0.010 | 0.007 | 0.007 | 0.002 | 0.004 | 0.000 | -0.111 | -0.110 | 0.028 | 0.011 | 0.025 | -0.016 | -0.007 |
| lat | 0.011 | -0.019 | 0.055 | 0.027 | 0.104 | -0.004 | 1.000 | -0.151 | 0.451 | -0.026 | 0.115 | 0.031 | 0.027 | -0.129 | -0.120 | 0.068 | 0.034 | -0.122 | 0.026 | 0.255 |
| long | 0.260 | 0.196 | 0.084 | 0.143 | 0.223 | 0.010 | -0.151 | 1.000 | 0.060 | 0.387 | -0.194 | 0.288 | 0.382 | 0.378 | 0.382 | 0.078 | 0.089 | 0.410 | -0.073 | -0.583 |
| price | 0.500 | 0.353 | 0.020 | 0.324 | 0.657 | 0.007 | 0.451 | 0.060 | 1.000 | 0.543 | 0.254 | 0.645 | 0.572 | 0.071 | 0.060 | 0.216 | 0.336 | 0.101 | 0.106 | -0.007 |
| sqft_above | 0.690 | 0.544 | 0.109 | 0.597 | 0.709 | 0.007 | -0.026 | 0.387 | 0.543 | 1.000 | -0.161 | 0.844 | 0.694 | 0.277 | 0.259 | 0.094 | 0.099 | 0.466 | 0.040 | -0.280 |
| sqft_basement | 0.195 | 0.237 | 0.096 | -0.275 | 0.095 | 0.002 | 0.115 | -0.194 | 0.254 | -0.161 | 1.000 | 0.332 | 0.137 | 0.037 | 0.032 | 0.164 | 0.144 | -0.177 | 0.062 | 0.109 |
| sqft_living | 0.744 | 0.653 | 0.060 | 0.396 | 0.714 | 0.004 | 0.031 | 0.288 | 0.645 | 0.844 | 0.332 | 1.000 | 0.746 | 0.308 | 0.289 | 0.157 | 0.156 | 0.347 | 0.060 | -0.211 |
| sqft_living15 | 0.566 | 0.447 | 0.061 | 0.298 | 0.656 | 0.000 | 0.027 | 0.382 | 0.572 | 0.694 | 0.137 | 0.746 | 1.000 | 0.365 | 0.372 | 0.151 | 0.096 | 0.328 | -0.001 | -0.288 |
| sqft_lot | 0.067 | 0.215 | 0.011 | -0.236 | 0.149 | -0.111 | -0.129 | 0.378 | 0.071 | 0.277 | 0.037 | 0.308 | 0.365 | 1.000 | 0.924 | 0.046 | 0.015 | -0.040 | 0.012 | -0.329 |
| sqft_lot15 | 0.061 | 0.199 | 0.010 | -0.234 | 0.155 | -0.110 | -0.120 | 0.382 | 0.060 | 0.259 | 0.032 | 0.289 | 0.372 | 0.924 | 1.000 | 0.037 | 0.000 | -0.017 | 0.010 | -0.336 |
| view | 0.120 | 0.038 | 0.026 | 0.025 | 0.146 | 0.028 | 0.068 | 0.078 | 0.216 | 0.094 | 0.164 | 0.157 | 0.151 | 0.046 | 0.037 | 1.000 | 0.614 | 0.042 | 0.111 | 0.075 |
| waterfront | 0.121 | 0.000 | 0.024 | 0.025 | 0.127 | 0.011 | 0.034 | 0.089 | 0.336 | 0.099 | 0.144 | 0.156 | 0.096 | 0.015 | 0.000 | 0.614 | 1.000 | 0.033 | 0.092 | 0.082 |
| yr_built | 0.562 | 0.180 | 0.251 | 0.550 | 0.502 | 0.025 | -0.122 | 0.410 | 0.101 | 0.466 | -0.177 | 0.347 | 0.328 | -0.040 | -0.017 | 0.042 | 0.033 | 1.000 | -0.216 | -0.312 |
| yr_renovated | 0.049 | 0.024 | 0.068 | 0.020 | 0.021 | -0.016 | 0.026 | -0.073 | 0.106 | 0.040 | 0.062 | 0.060 | -0.001 | 0.012 | 0.010 | 0.111 | 0.092 | -0.216 | 1.000 | 0.062 |
| zipcode | -0.203 | -0.171 | 0.076 | -0.057 | -0.180 | -0.007 | 0.255 | -0.583 | -0.007 | -0.280 | 0.109 | -0.211 | -0.288 | -0.329 | -0.336 | 0.075 | 0.082 | -0.312 | 0.062 | 1.000 |
Missing values
Sample
| id | date | price | bedrooms | bathrooms | sqft_living | sqft_lot | floors | waterfront | view | condition | grade | sqft_above | sqft_basement | yr_built | yr_renovated | zipcode | lat | long | sqft_living15 | sqft_lot15 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 5100402668 | 20150218T000000 | 495000.0 | 3.0 | 1.00 | 1570 | 5510 | 1.0 | 0 | 0 | 4 | 7 | 1070 | 500 | 1940 | 0 | 98115 | 47.6942 | -122.319 | 1770 | 6380 |
| 1 | 7856560480 | 20140808T000000 | 635000.0 | 3.0 | 2.50 | 1780 | 11000 | 1.0 | 0 | 0 | 4 | 8 | 1210 | 570 | 1980 | 0 | 98006 | 47.5574 | -122.149 | 2310 | 9700 |
| 2 | 2872900010 | 20150414T000000 | 382500.0 | 3.0 | 1.50 | 1090 | 9862 | 1.0 | 0 | 0 | 3 | 8 | 1090 | 0 | 1987 | 0 | 98074 | 47.6256 | -122.036 | 1710 | 9862 |
| 3 | 3216900070 | 20140617T000000 | 382500.0 | 4.0 | 2.50 | 2210 | 7079 | 2.0 | 0 | 0 | 3 | 8 | 2210 | 0 | 1993 | 0 | 98031 | 47.4206 | -122.183 | 1970 | 7000 |
| 4 | 976000790 | 20141020T000000 | 670000.0 | 3.0 | 2.50 | 1800 | 4763 | 2.0 | 0 | 0 | 3 | 7 | 1240 | 560 | 1985 | 0 | 98119 | 47.6460 | -122.362 | 1790 | 4763 |
| 5 | 6815100085 | 20141224T000000 | 1001000.0 | 4.0 | 2.00 | 3100 | 8000 | 1.5 | 0 | 0 | 5 | 7 | 2040 | 1060 | 1939 | 0 | 98103 | 47.6852 | -122.329 | 1650 | 4000 |
| 6 | 7237550020 | 20140703T000000 | 1100000.0 | 4.0 | 3.75 | 5070 | 60123 | 2.0 | 0 | 0 | 3 | 11 | 5070 | 0 | 2000 | 0 | 98053 | 47.6567 | -122.004 | 4920 | 101930 |
| 7 | 1231000310 | 20140812T000000 | 713000.0 | 1.0 | 1.00 | 1180 | 4000 | 1.5 | 0 | 2 | 4 | 8 | 840 | 340 | 1910 | 0 | 98118 | 47.5561 | -122.266 | 1420 | 4000 |
| 8 | 8663260030 | 20141118T000000 | 416000.0 | 3.0 | 2.50 | 1800 | 5372 | 2.0 | 0 | 0 | 3 | 8 | 1800 | 0 | 1987 | 0 | 98034 | 47.7188 | -122.177 | 1650 | 6014 |
| 9 | 1160000115 | 20150304T000000 | 401000.0 | 4.0 | 1.75 | 3010 | 12523 | 1.0 | 0 | 0 | 3 | 8 | 1780 | 1230 | 1952 | 0 | 98125 | 47.7070 | -122.316 | 2040 | 7560 |
| id | date | price | bedrooms | bathrooms | sqft_living | sqft_lot | floors | waterfront | view | condition | grade | sqft_above | sqft_basement | yr_built | yr_renovated | zipcode | lat | long | sqft_living15 | sqft_lot15 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17280 | 6738700005 | 20140529T000000 | 395000.0 | 2.0 | 1.00 | 1320 | 1824 | 1.5 | 0 | 0 | 4 | 6 | 1320 | 0 | 1909 | 0 | 98144 | 47.5850 | -122.294 | 1320 | 4000 |
| 17281 | 2902200915 | 20141125T000000 | 675000.0 | 3.0 | 1.75 | 2130 | 4400 | 1.0 | 0 | 0 | 3 | 7 | 1430 | 700 | 1922 | 0 | 98102 | 47.6417 | -122.325 | 1710 | 3300 |
| 17282 | 3022900070 | 20140929T000000 | 348000.0 | 3.0 | 2.00 | 2360 | 6145 | 1.0 | 0 | 0 | 3 | 8 | 2360 | 0 | 2011 | 0 | 98030 | 47.3564 | -122.198 | 2304 | 5880 |
| 17283 | 6917700195 | 20140728T000000 | 585000.0 | 3.0 | 1.75 | 1480 | 4800 | 2.0 | 0 | 0 | 4 | 7 | 1140 | 340 | 1944 | 0 | 98199 | 47.6567 | -122.397 | 1810 | 4800 |
| 17284 | 1105000402 | 20141028T000000 | 630000.0 | 4.0 | 3.00 | 3640 | 5096 | 2.0 | 0 | 0 | 3 | 8 | 2740 | 900 | 2010 | 0 | 98118 | 47.5428 | -122.270 | 1910 | 9189 |
| 17285 | 2322069010 | 20141007T000000 | 1180000.0 | 5.0 | 5.00 | 3960 | 94089 | 2.0 | 0 | 0 | 3 | 10 | 3960 | 0 | 1998 | 0 | 98038 | 47.3800 | -122.011 | 2240 | 64468 |
| 17286 | 2114700368 | 20141118T000000 | 299000.0 | 2.0 | 2.50 | 1400 | 1262 | 2.0 | 0 | 0 | 3 | 8 | 1160 | 240 | 2008 | 0 | 98106 | 47.5342 | -122.349 | 1060 | 1524 |
| 17287 | 5469501200 | 20140820T000000 | 431000.0 | 3.0 | 2.25 | 2360 | 14950 | 1.0 | 0 | 0 | 4 | 9 | 2360 | 0 | 1978 | 0 | 98042 | 47.3856 | -122.158 | 2720 | 14388 |
| 17288 | 3751602797 | 20140702T000000 | 411000.0 | 4.0 | 2.00 | 2370 | 76665 | 2.0 | 0 | 0 | 4 | 8 | 2370 | 0 | 1978 | 0 | 98001 | 47.2831 | -122.279 | 2110 | 19334 |
| 17289 | 4038600260 | 20140922T000000 | 699900.0 | 4.0 | 2.25 | 2380 | 16236 | 1.0 | 0 | 0 | 3 | 7 | 1540 | 840 | 1961 | 0 | 98008 | 47.6126 | -122.120 | 2230 | 8925 |